TrustRadius Insights
Seamless Querying Process: Many reviewers have praised the ease of connecting to Snowflake and other servers, indicating that they have …
Starting at $11 per month per user
View PricingOverview
What is DBeaver?
DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.
Recent Reviews
Popular Features
- Database change management (5)9.191%
- Schema maintenance (9)8.888%
- Database status reporting (6)8.484%
- User management (5)7.979%
Pricing
Lite Edition Subscription
$11
On Premise
per month per user
Enterprise Edition Subscription
$25
On Premise
per month per user
Lite Edition License
$110
On Premise
per year per user
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://dbeaver.com/buy
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $11 per month per user
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is DBeaver?
DBeaver is a universal database management tool, able to support SQL (MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle, and IBM DB2, Sybase, etc.) and NoSQL databases (MongoDB, Couchbase, Redis, Cassandra, etc.), as well as cloud databases (AWS Redshift, Google BigQuery, Snowflake, etc.).
Connection to various data sources
- Choice of database driver from the variety of supported types. The list of drivers includes drivers for relational, document-oriented, key-value, time-series, and other databases.
- Support of user-defined connection types and creation of custom drivers an the Driver Manager
- Configuration of standard (host, port, user credentials) as well as advanced connection properties:
- SSH tunnel
- SOCKS proxy
- Shell commands to be executed before/after actual database connection
- Bootstrap SQL queries executing in the database session immediately after connecting
Data viewer and editor
- Multiple data views to fit the variety of users’ needs, for example display of image contents (gif, png, jpeg, bmp) as an images
- Editing of data inline and in a dedicated space
- Navigation among data
- Custom filters for table contents or query results, including filters based on cell values
- Results ordering by column
- Data export with all applied filters and orderings
- Generation of SQL statements based on selected rows
- Basic statistics for selected columns
Mock-Data Generator
The user can generate random data (or “mock" data) for tables. And this data should look like the real data. Enterprise edition includes basic and advanced data generators. Including (but not limited to):
- Numbers
- Random strings
- Names
- Addresses
- Credit cards
- Domains and IP addresses
- Custom regular expressions
- Flexible numeric generators
SQL editor
- Organization of scripts into folders and reassignment of database connections for particular scripts
- SQL syntax highlighting determined by the database associated with a script
- Support for different sets of reserved keywords and system functions for different databases
- Import and export of scripts
Visual Query Builder
- Construct complex SQL queries without actual knowledge of SQL
- Make table joins/filtering/ordering visually
- Open existing SQL queries in visual mode, edit and save them
- Execute a visually constructed query at any moment and get results on the screen
- Analyze complex SQL queries visually
Metadata browser
- A tree of database connections with their metadata structures down to the lowest level: tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions), and security entities (users, roles)
- Ability to modify most metadata entities, depending on the database driver capabilities
- Display of database objects` DDL and generation of standard SQL92 DDL according to object structure for some databases
- Ability to edit/rename/delete connections and most database objects
- Global and local filters, ability to filter database objects by name
Data transfer
- Export of data to a file or to another database table with the option to create the destination table if it does not exist
- Supported file formats: CSV, HTML, XML, JSON, XLS, XLSX
- Import data directly from CSV file into database table. Setup columns mapping and data types in convenient wizards
- Save data transfer configurations as tasks and run them in one click
- Schedule data transfer tasks for later/recurrent execution
ER diagrams
- Automatically generated ER diagrams for a database/schema (with all tables) or for a single table (with all referenced/referencing tables)
- Customization of columns visibility
- Export of diagrams to the formats: GIF, PNG, BMP, GraphML
Data and metadata search
- Full-text data search against all chosen tables/views with search results shown as filtered tables/views
- Metadata search among rows in database system tables
- Ability to set an exact object name or a search mask
Database structure compare
- Ability to compare several database objects of any type: tables, schemas, entire databases, etc.
- Comparison results can be presented as: HTML, DDL alter scripts, Diff diagram, Liquibase changesets
- Database structure synchronization can be performed
While DBeaver offers a community edition at no cost, users of the Enterprise Edition have an access to the special online support system. They can write a ticket with question, bug or improvement and track it from the profile. The vendor states it usually takes no more than one working day to answer questions, and just a few days to fix bugs reported by the users.
DBeaver Features
Database Development Features
- Supported: Version control tools
- Supported: Test data generation
- Supported: Database change management
Database Administration Features
- Supported: User management
- Supported: Database security
- Supported: Database status reporting
- Supported: Change management
DBeaver Video
This demo video describes the main features of DBeaver
--
0:05 Connections
01:07 Cloud Explorer
02:08 Data Editor
04:04 Grid Colorization
05:36 Data Highlighting
07:04 Data Visualization
08:09 Spatial data
09:05 Value Panel
11:53 Calc & Group Panels
13:06 SQL Editor
16:4...
 Show More DBeaver Competitors
DBeaver Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows, Linux, Mac |
| Mobile Application | No |
Frequently Asked Questions
DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.
DBeaver starts at $11.
Reviewers rate Database change management and Change management highest, with a score of 9.1.
The most common users of DBeaver are from Small Businesses (1-50 employees).
Comparisons
Compare with
Reviews and Ratings
(55)Attribute Ratings
Reviews
(1-4 of 4)Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
DBeaver is used by me to work with SQL Server databases.
- Identify types of DB connections by color code: development, testing and production.
- Predictive typing, it is incredibly accurate and saves me a lot of time.
- Jump between different simultaneous DB connections.
- Navigate through the schema object tree.
- Provide all the tools I need in one window.
- Some icons are kinda small and difficult to understand what they do
- The spanish translation could be better
- I think there are many functions that could be useful for me but I don't know what they do
20%
2.0
N/A
N/A
- Reduced substantially the time required by database maintenance operations
- Reduced the error rate when modifying database objects
- Improved the speed of query creation for data analysis purposes
SQL Server Management Studio (SSMS) developers should take a look at DBeaver to see how a real management studio application should be. In DBeaver you can tell that the developers really think about the way DBAs and database developers use database management tools. With SSMS, Microsoft tries to continue evolving an old and cumbersome application that does not seem to improve with each new version.
October 04, 2021
DBeaver - A Great Open Source Tool
We use DBeaver to connect to our Snowflake instance, as well as our on-premises Microsoft SQL servers. It is very nice because we can query both without having to have an application for each. I find that DBeaver is able to generate the DDL behind Snowflake views much easier than in the Snowflake IDE.
- Querying against Snowflake
- Personalizing formatting of T-SQL
- Easily connect to Snowflake and other servers
- Engaged and caring community
- I would like an option to configure key shortcuts further.
- I would like an option to automatically invalidate /refresh connections after a period.
- It would be helpful if there was a more intuitive way to "code together".
77.5%
7.8
77.5%
7.8
- It's hard to estimate ROI as it's a free tool - but it's a great tool to use.
- By using DBeaver amongst the team, we're more easily able to collaborate.
- DBeaver is very easy to set up and connect, so there was very little trouble onboarding new engineers and getting them providing value.
We found that sharing scripts and generating DDLs from Snowflake's IDE was a bit too much of a chore. Because of this, we began looking for alternate products. We found DBeaver, a free community tool, and tried it out. We've found that it is very intuitive and easy to use, I would recommend it.
August 31, 2021
DBeaver Offers a Great Feature Set for Free
I use DBeaver as a graphical interface for accessing databases locally and remotely for testing and data analysis. It allows easy access to viewing data and running SQL Queries against the data as well as updating test data locally.
- Running SQL Queries
- Displaying data
- Sorting data
- Viewing multiple tables
- UI can be cumbersome and confusing
- Constant updates creates multiple reminders
34%
3.4
20%
2.0
- Easy access to test data locally
- Easy ability to manipulate data locally for testing
- Easy ability to view and sort data for analysis
January 23, 2019
Great DB development tool!
Our development staff uses DBeaver for editing database/table schema (when needed) and for creating production deployment scripts. We are using the free community edition and it is extremely stable and works very well. Since it supports multiple databases, we can also use it for Microsoft's SQL Server, but we currently only use it for PostgreSQL. Compared to other products on the market, it did what we needed to do, even though sometimes the UI can be a little unintuitive compared to what we are used to with SQL Management Studio.
The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.
While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.
While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
- Data import/export and SQL Script generation are quick and simple to do.
- Fairly intuitive when viewing/editing table data.
- Ability to save SQL scripts per server and recall them easily.
- Handy intelligence when writing queries, functions, and stored procs.
- Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
- Sorting and filtering in data is nice, but buried in long right-click menus.
- Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.
90%
9.0
85%
8.5
- Saved our development team hours of work handcrafting database deployment scripts by generating DDL scripts for us.
dbForge Studio has a more intuitive UI for die-hard Windows users. It's also easier to use sorting and filtering in their grids. However, that one lacked the script generation and schema editing tools our development team needed to use on an almost daily basis.
Valentina had the features they needed, but the UI was just not palatable for them to use.
Valentina had the features they needed, but the UI was just not palatable for them to use.